The Northern Competitions Stadium will be hosting a different form of entertainment in June, with the pitch transformed into a campsite.