The Californian artist, who died of pneumonia, was known and eventually loved for his massive rusting steel structures now housed in museums around the world