Sidewinder by Citizen Games will have some (well, it's a wild west game and you spend a lot of time in saloons!).
It's not out yet (I did some playtesting on it) and they probably won't be open content but I'll give you the short version:
Fort save with a DC that increases cumulatively with each drink you have. Failing a save decreases certain stats and you can keep on drinking until a stat reaches zero. Needless to say, when you're drunk, you stats go down the toliet!
I thought it was a good representation on alchohol, better that using it as a poison.
Look for it soon, it's supposed to be out in the sping sometime.