The Kevin de Bruyne era is over for Manchester City as Pep Guardiola faces up to a squad overhaul at the Etihad Stadium.