Sir Chris Hoy is confident the recent investment in sport north of the border will pay dividends at next year's Commonwealth Games.