A huge new project to transform Oldham’s sports grounds will attract up to 25,000 weekly visitors to the borough, it is hoped.