Manchester City confirm Pep Guardiola will leave at the end of the season after a decade of unparalleled success.