At The Breakers, all the bathrooms had hot and cold running fresh and salt water. I believe many of the fancy mansions in that area had.
I remember visiting on a field trip from nerd sleepaway camp in Massachusetts.
As an adult, I could see myself splurging to get running salt water in my seaside mansion. I've always loved salt water.