Pep Guardiola says the club needs a new manager and new energy after he announced his decision to leave Manchester City at the end of the season.