I have a small similar fountain that I use for my cats. They like it. It makes a horrid noise when the water gets too low and it's a bit of hassle keeping the pump clean, but the cats do like it and drink more with it.

That site is in pounds BTW, so the actual cost is double in Canadian dollars.