Councillor sacked after posting sexualised AI image of colleague BBC