Councillor sacked after posting sexualised AI image of colleague Yahoo