Heat pump water heaters pull heat from the outside. Usually with a split outdoor unit, just like normal A/C and heat pump systems.
I’ve also seen models where the entire system (integrated storage cylinder for the heated water) is installed outdoors, but those are presumably meant for more mild climates.
In any case, they certainly don’t pull heat from inside the house.