Located at the north end of the Sacramento Valley , Shasta Dam creates Shasta Lake for long-term water storage , flood control , hydroelectricity and protection against the intrusion of saline water .