The head of Drinkaware, the UK alcohol education charity, has announced his intention to stand down.