By-election to be held in Lancaster ward after councillor resigns