The player-turned-coach is leaving Manchester City after delivering one of the most successful eras in the club’s history