If the sleepiness is caused by not getting enough sleep, "fixing" it with stimulants will be very bad for your health. Don't go any stronger than coffee, at the most, or you're seriously asking for trouble. Remember all those drugs that have killed people when they were called perfectly safe, and remember that Red Bull and the like are not tested anywhere near as thoroughly. Labels like "herbal" and "all natural" are not to be trusted- they really mean "untested" and "we have no idea how this works, but we're putting it in your food to make a buck".
Maybe you're just drinking or absorbing the alcohol too quickly. Try smaller portions, timing yourself, eating before you go out as mentioned earlier...oh, and don't forget a glass of water between drinks. Don't be ashamed to drink less than your friends.
If coffee doesn't do it, and you're not drinking too much, and you're getting enough sleep, maybe you're just a lightweight. This is not a bad thing. Be glad you don't have to worry about becoming an alcoholic.