You had better be ready to clean it often

I tried a cat water fountain and found that cleaning it is way too much of a hassle. The better solution was to dedicate a half bath's sink to just the cat. The cat loves to jump up and drink from the clean (soap-free) sink and cleaning it is a cinch. Cleaning a cat fountain is definitely not a cinch.

It would be better if homes would have cat fountains built into bathrooms but they don't so I has to improvise.

I will recommend these things only for those prepared to clean it. If you have a demanding job like me, reconsider.