Pros - this is nice and quiet. I was worried the water noises might keep me up at night, but its pretty much silent. You don't hear any drips or fountain noises.  There is a slight hum of the pump/motor running but its extremely quiet.   This also does a great job recycling the water. It needs to be filled every few days.  The water stays fresh. The setup was simple. The cats loved it!
Cons - (if you can call them that) this is for cats, as clearly stated on the product. My dog seemed to mess it up regularly. Each time I would check the pet fountain there would be water underneath the base, causing my floor to be wet.  In a multi pet home (two cats, one dog) the dog seemed enjoy this the most...but was constantly making a mess.  If you have dogs, you may want to reconsider.  If you only have cats, lucky you, you'll love this fancy fountain and so will they!