Pep Guardiola to succeed Pellegrini at Manchester City