A senior councillor has resigned amidst a bullying scandal that has taken hold of Newcastle City Council.