This fountain is exactly what I expected based on other reviews. 
I need to add water almost every day when it is warm outside. The sound is pleasant, and not too loud.
I struggled to get the suction cups on the bottom of the pump to stick, but then just put it in the bottom of the base and connected it to the tubing and it works fine.