Councils found to have minimal gender diversity as 97% still male-dominated