I don't remember what brand mine is, but I got one a few mos ago on the recommendation of my vet, and my cats love it. It was hilarious when I set it up... I put it near their food bowl and about a two feet away from the water fountain all three sat in a line just staring at the fountain for a few minutes... they didn't know what to make of it. I did leave their old water bowl out until I was sure they had all switched to the fountain.
My vet really encouraged switching to the fountain because it supposedly helps cats drink more water, since most cats apparently do not get enough water.
Mine is super quiet unless the water gets low. My now two cats drink about one reservoir full of water a day, so I just fill it up every morning and it never even starts being loud. Just like a regular bowl, you have to clean it regularly and the cleaning is a little more involved, you have to take everything apart but really, not difficult.