Pep Guardiola to succeed Manuel Pellegrini at Manchester City