The owner of one of the oldest craft brewers in my area once told me that "nothing that can hurt you can grow in beer." I don't know if this is completely true, but this might render fresh water with many types of dangerous pathogens safe to drink.
One famous story of historical excess drinking is associated with the U.S. constitution...
https://www.wearethemighty.com/mighty-history/george-washint...
Finally, there is an easy method for most people reduce their impulse to drink temporarily by the use of the opioid blockers naltrexone or nalmefene. These can be used either for a goal of reduced-compulsion abstinence or long-term controlled drinking.