The modern approach is reverse osmosis, forcing water through a semipermeable membrane. This article from the trade association says they can do it for about 0.1 kwh of electricity per cubic foot of water. Or, according to their calculations, the electricity used for all the water for one household is about equal to the electricity used by a refrigerator.