Water auto fill system for outdoor fountains