There was Ambrosia
in BSG & Caprica.
TOS Battlestar also had the obscure Buzzer
adult beverage that was like homemade moonshine. Additionally, TOS also had the more generic (and not too imaginative) Ale
If you want to get into the harder stuff, there was also Smoking Plant Vapors
that I'm guessing was like Colonial weed.
has a bunch as well.