I saw a video showing a water bowl for a cat that used an upside down PET bottle to provide "fresh" water when cats consume some of the water in the bowl. I wanted to design something similar.
Here is a very very high level sketch:
The idea is that an upside down water bottle is screwed into the top hole (on the left) and some sort of piping will lead the larger hole on the right to fill up with water. Naturally due to the pressure the water will overflow in the hole on the right.
My question is: Is there a way to prevent the water from overflowing in the lower basin when a water bottle has much more water stored than the basin can hold? I am very unversed in those topics so I unfortuantely even failed to find the right terms to search for in google...