B.C. city councillor resigns after sexual assault conviction