Bilbao's Guggenheim Museum transformed the face and fate of Bilbao when it opened in 1997.