You just need a spot market for electricity and then you can program the water heater to follow the spot price (or rather avoid heating when it's expensive).

This is available already in a few heat pump water heaters in Finland.