Instructables user JimTiffinJr's 11-year-old daughter created an automatic water dispenser for her pet dog by lining up a bottle up with the inside of the bowl so once it becomes submerged it won't any more water flowing out.
Check out the instructions over here:
Instructables