The alternative to a huge well - the trough. Water pumped fresh from below for your mount or self to drink from. Thats if you can use it as it is sometimes used by the local drunk to spend the evening/morning sleeping in.
 
This Beautifully sculpted trough is cast in high quality resin as a two part piece .