As advertised, my Freestyle leaks coolant; in this case, water, because the prior

There's the leak

owner (PO) just filled the cooling system with water as coolant steadily leaked out.  The water leak was enough of a trickle that the car could be driven home, the PO telling me the coolant needed to be refilled every day or two. I think this was the critical reason why the car was on the market.  The oil leak seemed to be something that could tended to on a weekly basis, this problem was every few days.  From the PO's perspective, the leak was coming from the radiator.

I was looking forward to be working through a "mystery leak", this would be fun (hey, don't judge) to track down and make for more interesting content for you, the reader.  What the PO believed to be a leaking radiator wasn't that at all -- this is both good and bad news.  Debugging the problem was easier than expected, after getting the car home, there was a nice steady drip visible from under the car that we traced to the bottom of the water pump.  I spent time looking over the radiator and I didn't see any leaks.

The water pump is at the top of the engine and easily accessible.  Feeling the underside of the pump, I felt what seemed to be the source of the problem: the water pump is two halves and the seal between the halves failed, thus causing the leak. To check my inkling, I needed to remove the pump and have a good look.

Staining from coolant

Removing the water pump first required the removal of the air intake, then the  thermostat manifold which required removing about 20 water hoses.  The hoses felt like they hadn't been moved since the date of manufacture and didn't want to budge.  Not having a proper radiator hose pick, I used a small screwdriver to separate the rubber from the manifold, fearing I would split the hose.  But, I managed to loosen the hose from the fitting while keeping everything intact.

Getting a good look at the pump reveals that the leak isn't from the front gasket as originally suspected, but from the back.  The water was adhering to the pump

Crystallized coolant

housing and giving the appearance the leaking coming from the pump gasket.  The leak left a clear discoloring on the part from the leaking fluid, and there were deposits on the end of the impeller shaft, so that’s the problem. 

The root cause, a failed seal

Just to make extra-double sure, I used my 8mm socket disassemble the pump and then using a hammer and 10mm deep-well socket, removed the impeller from the housing.  Here you can clearly see the failure of the seal on the impeller shaft, so I'm sure that's the problem.  After much digging, I found that, for this car at least, you cannot purchase just an impeller, so I'll need to buy a new water pump.

At the same time, the camshaft seal was clearly leaking oil.  This resulted in the deposits on the top of the engine and maybe was the source of the oil on the lower part of the engine as well.  The oil leak doesn't look that bad, but it will worsen over time, so best to replace the seal at the same time as the water pump.