This formerly down-at-heel port has been transformed into a vibrant city with plenty to please culture vultures, plus exciting new places to eat and drink.