we have one - it's ceramic - this one:
Drinkwell Lotus Multi Level Pet Fountain - DMLT-CER
Our cats and Pluto love it. They drink a ton of water from it. We clean it every week or two. It's easy to clean - a slight pain to put back together - but I'm convinced they actually drink more water with it than just a bowl.