The New Zealand Health Education Association produced this helpful resource which covers alcohol and other drugs.
Some activities are alcohol-specific, but many of the teaching and learning processes can be applied to any drugs, requiring only minor changes to the scenario or naming of the drug.