Two-thirds of local authorities in Scotland are considering introducing a visitor levy following confirmation of the country’s first scheme in Edinburgh, a study has found.