There are many different cannabis strains you can try, and not all of them will make you sleepy. Some can actually give you energy and make you pretty talkative.
I am not fully understanding your question though. Are you looking for another substance to replace alcohol, or are you looking for...