Are more expensive chains/casettes more quiet?
I think a well-adjusted, modern system from any of the major players in components will be reasonably quiet and generally the same volume level. The trick is to make sure your cable tension, limit screws, and derailleur alignment are tip top. But that's true even if noise isn't an issue.

In your case, I would guess that your trainer will be much louder than your drivetrain.