drunk as a skunk
Definition from Wiktionary, the free dictionary
Although skunk might refer to the aroma of alcohol etc, the rhyme seems to have motivated this idiom.
Usage notes 
- This term follows the common pattern of omitting the first "as" of the full form "as drunk as a skunk".
drunk — see drunk