A captivating mix of Old Town alleys, genre-spanning architecture and museums, plus tempting markets and restaurants, makes this Pyrenees city a worthwhile destination, says Anna Richards