North West’s tourism sector is ‘ripe for investment’