After only being open to essential workers and essential travelers since March, the Bay Area city’s hotels can now welcome tourists again.