Koalas calm themselves quite a bit with the help of Eucalyptus.
Many birds become intoxicated from fermented berries.
Some goats will drink down entire cans/bottles of beer if trained and given the chance (one became mayor).
"Party Animal" has some literal examples in nature.