The Stadium for Cornwall will become the home ground of the Cornish Pirates RFC and the Truro City Football Club