Actually lake mead in game is radiation free, maybe not that realistic but fallout 3 purified the Delaware river by building a giant water purifier in the Jefferson monument, which happens to be at the river's delta, which flows into the ocean. How exactly purified water goes upstream remains a mystery.