Design-led new hotels, a dynamic food scene, and a boom in contemporary arts make this ancient city a destination in its own right, says Kate Lough