Solar-Powered Sustainable Water Production: State-of-the-Art Technologies for Sunlight–Energy–Water Nexus