I have a Minoura magnetic trainer that's been going strong for over a decade. At high speeds, 40km/h+, it tends to "whine" or buzz a bit. The one I have came with an extension that supported the front fork as well as a remote for resistance adjustment. (I usually just kept it on "LOW" and upshifted for more resistance - I wouldn't buy a remote if I were buying another trainer)
I understand many models are very quiet. Wind trainers are probably the more noisy followed by mag, then fluid BUT there are probably badly designed fluid trainers that are noiser than some well designed wind models.
Best bet: go to some stores and try a few out!
Minoura, Blackburn, Elite Cycleops seem to be big brands.