I don't think there's much for _consumer _single heat pump systems that do both. I've seen a few, but mostly it's just a tiny heat pump built into the cap of a traditional water heater.

Worth pointing out that the nature of a heat pump is that the housewide heat pump is pumping warm air into the house to make it available for the water heater, which then pumps that warm air into the water. So it is just one big machine, fundamentally.

The criticism of the heat pump water heater: they're loud. A high frequency compressor buzz while operating. If you are switching to one, make sure it is located somewhere where the noise won't bother you. Mine is in a mechanical room in the middle of my house and it is annoying when operating -- I program it to run at night and close doors when going to bed. If I could do it over again, I'd put in in the (insulated) attic in spite of all the risks involved in that. More hot air available for it to use up there anyway.