A former senior civil servant is set to lead an independent audit to assess the "effectiveness" of industry-funded charity Drinkaware in the UK.