Rollers are quieter. 1up makes a cpr trainer that's supposedly quieter than the magnetic or fluid trainers, plus it won't leak. There's a lot of discussion about trainers and rollers on the Roadie forum. One trick to increase resistance on the rollers was to slide a towel underneath the rollers to provide some friction.

You will work up a huge sweat on trainers and rollers so a fan is often recommended. Also a mat or towels to catch the sweat. Since the trainer lifts the rear wheel off the ground a bit, you'll need to get a riser for the front tire or you'll be pedalling downhill.

There are lots of DVD's to help you exercise on a trainer/roller. I enjoyed watching TdF videos while using the trainer at my LBS.