Brighton & Hove city councillor resigns with immediate effect