Sheffield faces by-election after Southey councillor resigns unexpectedly