A national water grid would be incredibly expensive for what it provides.
I wonder how feasible it would be to have the federal government get California to relinquish some of its rights to the Colorado River in exchange to help fund desalination plants. Then the Colorado River can go more towards providing water to landlocked states in the southwest that don't have such an option.