Pros: Haven't met a cat yet that doesn't like it
Cons: Need to buy filters...theoretically :- )
I've tried a number of fountains with cats who had stopped drinking, or had adopted the habit of drinking from water taps, which is high maintenance.
This is the first one that the cats enjoy. It takes some effort, but very little. The cleaning is simple and it's quiet. You do need to plug the thing in, so you need to be close to a plug.
The drawback is the filters. I've been extending the life of each filter by rinsing them, and only discarding them when they seem quite ragged. They're also not recyclable, which I don't like. (Online, there were a few people who recommended alternatives to the filters, so you can search for those.)
But, after having this fountain a few years, I do highly recommend it, since it solved a long-standing problem for me and the furred ones.