If you like going to the taverns and buying drinks to find information for your journal, you can remove your intoxication by saving and reloading your game, even after the bartender refuses to give you any more drinks.