A Brighton councillor has resigned to take up a new job in a move that will trigger a by-election – the sixth since the local ...