I have the fountain in Catlady's link, and Fister likes it. It comes in two sizes, as you probably know already. Cats likes fresh water, just as we do, so I change the water every day. It's actually quite easy... I have a little bowl next to it I pour th ewater into, and I have a jar which contains the amount of water to fit into the Fresh Flow.

The water here has a lot of chalk in it and that will stick to it, so I clean it out once a week. I pour winegar in and let it soak for about an hour, that way the surface will still be smooth and easier to clean. Use a soft sponge.

As for the noise, the little slider on the pump can be adjusted so the water runs quicker or slower, that will also make it more or less noisy.

Hope the kitties like it!