I've owned cheap performance brand rollers made of PVC drums with the resistance unit for 8 + years. I don't tride them much anymore, as trainers are boring. They do make some noise, but no more so than your TV or stereo. You can ride them on carput, but the 'legs' will dig into the carpet just like a dining chair, but perhaps with more pressure. If you are really worried, buy a sheet of plywood and put some type of carpet over it to soak up the sweat. Put something, e.g carpet under the rollers regardless.

Personally, I live in a winter climate (not as bad as many) and ride all winter long. It is more fun in general to ride outside and I usually run my dogs that way. Not the best workout in the world or most focused, but it is some exercise and fun. The way I see it, riding real hills in CO on a fixie is as useful as riding rollers, but in a different way.

The concept of rollers/trainers kind of makes me think about the tools that drive 3 miles to a gym and then run on a treadmill. j/k Trainers have a place in the overall training regimen: I'm just not training for anything. If you live in CO, I'll sell you mine cheap.