cobaltman,
The small to medium size Nps-24 pipe lines for saltwater service could be in ductile iron material.
Some coastal cities have seawater piped in DIron to the fire hydrants and the seawater also used for street washing.
The entry level piping material for shipboard desalination units would be ductile iron. The Navy has a different situation on their submarines, and uses titanium for those desalination units. It is a matter of how much maintenance is needed and how much down time is acceptable for repair. The seawater materials of construction range upward to naval bronze, Cu-Ni, nickel alloys AL6XN, Hastelloy, etc. depending on temperature requirements.
Power plants at coastal locations use ductile iron pipe, or now use fiberglass pipe for cooling by seawater. Some larger diameter Nps-36+ use rubber lined steel pipe, but must deal with lining failures and eventual replacement.
Most underground mains are still ductile iron pipe, but the residential distribution potable water supply piping is now PVC or HDPE plastic piping. These could also handle seawater, as BigInch suggested. It will depend on pipe size, pressure, and length of line as to the economical choice.
Recycled water or effluent from waste water treatment plants might be more environmentally acceptable for storage lakes, as compared to seawater.