The £450m mega-project that's put a famous UK city back on the map