My cats both love the Petmate fountains: http://www.petguys.com/-029695248700.html
however, the pumps tend to burn out, especially if you let the water get low. I have had two of them and both pumps stopped working (even though I did clean them regularly). I think they may have been low on water at one point.
As a replacement, I got the Catit fountain: http://www.catsplay.com/catit.php3
One of my cats is okay with it, the other is not interested at all. Zoe will drink from it, but not as much as the Petmate
Mr. Odin will sniff near it, but he does not "get" the dome (at least that is what I think).
So...even though I hate the quality of the Petmate, I just ordered 2 new pumps from thier website. I am going to set one up and keep the extra pump for WHEN (not if) this one breaks. I figure that my kids are worth a new $20 pump every 6 months or so; especially if it means they are drinking enough.