Pep Guardiola said he will miss the Manchester City sporting director when he leaves at the end of the season