The senior councillor, who was already suspended by Scottish Labour, has stepped back from his role as leader of the local authority.