Assuming (and we all know what gets us!) you're going to fill a container with rain water and transfer from that into a drinking bowl of some sort, then the simplest answer is a float valve as mentioned before. You can get one that connects to a garden hose at a farm supply store and it will work reliably and refill the bowl when it gets low, no electronics involved.
Example valve here