Supreme Court quashes council CEO sacking, new council to abide by decision