Yes, San Francisco Airport Marriott Waterfront allows cats and dogs (limit 2 per room). There's a fee of USD 75 per accommodation, per stay. Service animals are exempt from fees.