This may be real blue sky, but perhaps the low power generated by small solar or wind stations could be used to crack water into hydrogen and oxygen, to be stored and then recombined (burned!) as needed for use as a fuel for transportation or heating.
Even small amounts, but generated over very long times could produce a usable amount of fuel with minor environmental impact.