North Tyneside Council says the £4.4 million venue is regarded as 'a game-changer for local football, rugby, and community sports'