An Introduction to puppy water dispenser
https://penzu.com/p/d0f9cf70
Only drawback is that the water will get hot in the bowl and in the hose, with the hot summer we are having - 100+ degrees. I just dump out the hot water, until the cool water starts to flow. Super convenient.