My kitty is the proud owner of a "Drinkwell" fountain. Yes! It's a bear to clean for the first few times. It gets easier with practice. I think it takes me about 20 minutes or so to clean the fountain now. The part I hate is getting the fountain to the sink without slopping water everywhere! I have to say kitty still likes to drink out of the kitchen faucet! But she does drink out of her fountain more!
The noise isn't too bad. I'm pretty sensitive to 'roars' but this is tolerable, to me.
This is the fountain we have.
http://smile.amazon.com/PetSafe-Drin...ilpage_o07_s01