The difference in chains and cassettes as you go up the price range is primarily weight saving and slick shifting. The noise that it makes is no different. The chains all come waxed so they're lubricated optimally and quiet, and the cassette has no impact on noise.
A well adjusted drive chain will shift smoothly without noise, the clicking when it's not shifting well is generally from poorly adjusted drive train. higher end stuff will shift quicker and smoother, but that's a small amount of noise.
As noted by others, the main noise is from:
- The trainer
- The wheel rotation
So the trainer is a resistance unit, the noise mainly comes from the contact of your tyre on the roller/resistance wheel. Make sure you use turbo specific tyres for wear, grip and noise reasons. Then it's the noise of the magnets/motor/resistance set up. Plus the vibrations of the motion transmitting through the frame.
Combined with the noise of your wheel/spokes cutting through the air.