The UK alcohol industry-funded charity Drinkaware has appointed a new chief executive, to start in January.