One of San Francisco's most popular tourist attractions has finally reopened after being closed for repairs for six months.