AIUI consensus is that people did drink water but also quite a lot of beer.
"Young children almost certainly didn't drink beer." - wanna bet?
> In his A Plan for the Conduct of Female Education, in Boarding Schools published 1797, writer Erasmus Darwin agreed that "For the drink of the more robust children water is preferable, and for the weaker ones, small beer ..."