The Manchester United legend will step down from his role as club ambassador at the end of the current campaign