Almost three quarters of the North's businesses anticipate steady and sustained growth over the next decade, according to a report.