I used to use bowls and what not but cleaning, filling, emptying every day is a hassle, or at least it's inconvenient when my birds drink about 10 gallons of water a day...
Now I use a 55 gallon drum with horizontal nipples, no cleaning, no hassle and the water is always clean... I installed a float valve in it, so I can either leave a hose connected so it's always refilled or I can simply hook the hose up every few days, no need to stand around while it fills...
There is also a heater, and small circulatory pump inside the 55 gallon drum, set to hold the water at about 45° in the winter, it's in my coop that I already heat to 35-40° so it should never freeze but I like to make sure...
For my goats and llamas, I cut a 55 gallon barrel in half and made a stand to hold it as a water trough, I have a hose suspended above it hooked up to a water timer, at 9am every day it automatically runs water for 10 minutes, overflowing the trough and putting in fresh water for the day... Llamas and goats are happy, they get fresh sold water daily and it stay pretty clean overall since it's flushed every day...
As an at home dad, with 3 young children anything I can automate makes life easier...