Two major cities in the UK that are popular among tourists could see a proposed new tourist tax cause financial havoc.