Pep Guardiola held back the tears in a message to Manchester City fans after announcing he will leave the club