A solar water pump is a good way to automate this process ... All you need to do is switch it on and place the water fountain in your birdbath or pond. That's it - you can have a working water ...

You can use a solar pump, like the Mademax Solar Bird Bath Fountain Pump, if you get plenty of sunlight during the day. If you place your fountain in the shade, try a USB battery-powered one ...