Update: Our puppy loves this fountain. She never was a big fan of her water bowl. She would always go outside and drink rain water that collected in the fire-pit cover
Now she is using the fountain all the time. I have just added water to it every day and the water is still crystal clear
I'll probably change the container into a bigger, heavier one as the puppy grows.