Leading architects can help to revive a city’s image but cultural institutions need long-term support to shine brightly