About half of the water supplied to Perth, WA comes from desalination. (Source:
https://www.watercorporation.com.au/Our-water/Desalination )
It takes 3.5kWh of energy to desalinate 1 cubic metre of water at the Perth plant. (Source:
https://www.amtaorg.com/wp-content/uploads/07_Membrane_Desalination_Power_Usage_Put_In_Perspective.pdf )
A solar farm such as this one planned for Cornwall
https://www.goodenergy.co.uk/media/1096/delabole-solar.pdf
takes up 25 acres and produces 3MW of electricity.
Reaching for my calculator shows that the power from that solar farm (when it's running at full output, i.e. when the sun's shining brightly) could desalinate 857 cubic metres of seawater per hour.
The average household consumption of water in the UK is around 0.35 cubic metres. (Source:
https://energysavingtrust.org.uk/sites/default/files/reports/AtHomewithWater%287%29.pdf )
Reaching for my calculator again shows that for each hour the 25 acre solar farm is producing maximum energy it could desalinate enough water for the daily requirements of 2455 homes. However it won't produce energy during darkness and it will run at considerably less output during cloudy conditions. Further, my calculations don't take into account the energy requirements of all the factories and offices where the residents of those homes will be working.
So the economics don't seem to be too good. In practice the Perth desalination plant draws much of its energy from wind power, rather than from solar power.