A historic UK city is becoming "hell on earth" as flocks of tourists resort to "urinating in the street" amid a "horrific" tourism boom.