If you drunk just reset the effects by sleep on your home
how do i get drunk
go to tavern, sit next to cho and drink red beer, few time untill you get stat drunk