I would simply love the idea of actually being able to go into a bar and get beer from an NPC on a multiplayer server, But since we don't really have NPCs worked out perfectly yet, i request a BEER MOD. Pretty simple when you think about it, Just yet another spawnable item could be added, BEER!
You can also do it like this: http://forums.bukkit.org/threads/fun-muddersmilk-v1-0-add-alcohol-to-your-milk-740-766.17015/
Would be great if a developer could pick this up and run with it to the point of being able to create stills and add beer as an item to the game. Who cares if you need a client mod, I know everybody on my server would be more than happy to put it on to be able to get tanked on minecraft! @nisovin, your mod is a step in the right direction ;D
If you modded the client, you could configure a GLSL shader to blur the screen when you're drunk. But that's just dreaming far beyond anyone would be willing to do.