A new visitor levy will allow mayors to impose a “modest” charge on overnight stays to invest in transport and infrastructure – but UKH said the “damaging” tax will be passed on to domestic tourists and fuel inflation