The power to tax tourists could enable councils in the Highlands and Aberdeen to invest hundreds of millions of pounds in local infrastructure and facilities.