The design of water-source heatpump goes something like this. There are two heat exchangers, one for the water to be chilled and another for the water that will be heated (some systems are reversible, so the heat source/destination can be switched; my system will not incorporate a reversing valve). Those heat exchangers put the refrigerant very close to the water, with only a thin layer of metal separating them. Between the loops are a compressor and a metering device, arranged so the compressor liquefies the refrigerant, the superheated refrigerant goes through one of the heat exchanger, to the metering device where it is expanded to a supercooled gas, then through the other heat exchanger, and back to the compressor.
My design uses loops of pipe for the heat exchangers. A small copper pipe is fed through a larger PEX pipe, the inner copper pipe will hold the refrigerant while the outer PEX pipe holds the water. This can be done with two copper pipes, one inside the other, but the PEX should be cheaper and provide a bit of insulation compared to using an outer copper pipe. The other common heat exchanger is a plate heat exchanger. plate exchangers are much more compact, and highly effective with large temperature differentials. My design calls for a very low temperature differential, hence the loop design.
When designing the loop heat exchangers you need to know how long the loops need to be made. I'm familiar with commercially available heat exchangers of a similar design, so I know roughly how large the piping needs to be, and roughly how long. But I wanted to know with better precision than that, and getting a straight answer out of an engineer can be a task. After much mulling about I've come to these design guides (which are based on experiments conducted at the University of Perdue, where the estimated error was <13%):