If you wish to use a heat pump water heater for space heating, and locate it within the same space (structure) you are trying to heat, you aren't accomplishing anything. Heat pumps of any type don't generate heat - they move and concentrate it. So, you'd be removing heat from the air, putting it into the water, and then releasing it back into the air. That doesn't get you anywhere.
Instead, look at air-to-water heat pumps, which capture heat from the outside air (yes, even when it's cold outside, there's heat energy in the air). The problem is, they are relatively uncommon in the U.S. (much more common in Europe) so they are expensive and not many techs can work on them. But they would likely do what you describe wanting to do.