Sure, it may sound a bit luxurious but it lets them enjoy fresh water and it also saves you time as you don’t have to continually change the water. It is also a fun toy for them as they like to play with the moving water source.
There are different types, styles and colors of cat drinking fountains. If you have multiple cats, you may need a larger one. Most of them have charcoal filters that you will have to purchase separately. Typically the water runs as a waterfall. Sometimes the water circulates instead.
Cat water fountains usually range in the $25 - $45 price range. There is no reason why you necessarily need a super pricey one. An affordable cat water fountain, as long as it’s large enough for the number of cats in your household, should do the trick.