Ex-director who oversaw Grenfell cost-cutting leaves council housing role after backlash