The simple answer is no. There was a time when Coffeeshops where allowed to sell alcohol to their guests but that time is over since some time. Mushrooms where never allowed to be sold in Coffeeshops but in so called Smartshops. If you want to smoke and drink you might have luck at one of the many smokers friendly bars around the city.