I have one I originally got for my cats, but Pixie drinks out of it too.
I think it's wonderful, the cats would always beg for me to turn the sink on so they could get a drink, but not any more!
Pixie seems to prefer drinking out of the fountain. She only has access to it when we're around to watch her (otherwise it's just her plain ol' bowl) and nine times out of ten, she'll use the fountain.
Just be sure to change the filter often 'cuz it does get dirty. I change mine every other week when I dump it out and scrub it down.
I have the one from Petmate.
http://www.petsmart.com/global/produ...t=fountain&N=2