We use a heat-pump water heater. It's just a standard water heater tank with an add-on heat pump unit that I bought off eBay. On average it uses about 1.2 kwh per day, for just my wife and I. When we had 2 of out grand kids living with us a couple years ago it was averaging closer to 2 kwh, mostly because our granddaughter takes long showers (teenagers, rolleyes)
During the summer it produces about 10,000 btus worth of cooling. Not a lot, but it's basically free.
I recently installed some duct work so it can pull warm air from under the roof during the winter which
should reduce it's winter-time energy requirements somewhat.
I considered using a Solar water heater, but talked to a few
local folks that had them first and changed my mind. Even though we live in southern Arizona, we still get some freezing weather during the winter, plus average daytime temps in winter are around 50F.
Freezing weather means that batch water heaters won't work during the winter, which means you need a system with anti-freeze, heat exchangers, pump(s), etc. The average power required to run those systems was around 500 wh a day, plus there was typically 3-4 weeks during the winter when they needed to use a backup heating system, which brought the average daily consumption up to around 800 wh.
However, the energy requirements were highest during the winter, when solar production is at it's lowest. Most of the people here use a standard electric water heater as a back up system and they were using 4,000-6,000 wh a day.
When you add in the energy value of the cooling the heat-pump provides during the summer, it was pretty much the same either way, with lower winter time energy requirements for the heat pump.
Final consideration was that the price of the Solar water heating systems (with the collectors, pumps, exchangers, etc.) started at around $5,000 and up, average price was around $7,000. That did not include installation.
I paid $365(delivered) for the heat pump on eBay:
https://www.ebay.com/itm/NEW-Heat-Pump-Water-Heater-SAVE-50-or-more-on-your-Hot-Water/282897050799?hash=item41ddfa6caf:g:RMQAAOSwj0NUa3~6
For off-grid, tankless is pretty much out of the question. The daily energy requirements will be almost the same as a heat-pump, but the instantaneous POWER requirements are huge.
With an add-on type heat pump you could use the tank as a diversion load for your solar array and just run the heat pump as needed. Actually with some clever controls you could use a resistance coil for a diversion load when you expect to have lots of surplus power and run the heat-pump as a diversion load when you expect only small amounts of surplus. You get the best of both that way.