Cllr Bernie Mooney, who many believed would be the authority's next leader, said she feels 'betrayed'