I don't think there's much for consumer single heat pump systems that do both. I've seen a few, especially with geothermal systems, 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 first 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. Or, if your air conditioner is running, the water heater heat pump is adding some cooling to the space.
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.