Newly elected Tory councillor featured leering at young women in ‘serial dads’ documentary