Yes, there is a Cabo San Lucas hospital as well as a variety of emergency clinics for Americans and Canadians. The hospital is located near the Baja Sur tip, close to the city.
Your other questions about whether the water is safe and whether there are American grocery stores has already been answered on my site. Just use the search function.
