Drunk as a skunk
This expression owes more to rhyming than any such behaviour attributed to skunks. It is an American expression dating from the 1950s.