A tourism tax will raise money in areas where councils choose to introduce it