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