Golden Gate City’s newest lifestyle hotel boasts a stunning rooftop lounge and draws design inspiration from the local neighborhood