skitzo2000 wrote:1.) It appears that it has an external pump rather than a crankshaft mounted one, am I right on that?
From the manual it appears external and on the drivers side. Here are the instructions for removal:
Removal and Installation
REMOVAL
1. Drain engine coolant. Refer to CO-10, "Draining".
CAUTION:
Perform this step when engine is cold.
2. Remove the following parts.
• Drive belt: Refer to EM-16, "Removal and Installation".
• Drive belt auto-tensioner: Refer to EM-26, "Exploded View".
• Alternator: Refer to CHG-21, "Exploded View".
3. Remove water pump.
• Engine coolant leakage from cylinder block, so have a receptacle ready below.
CAUTION:
• Handle water pump vane so that it does not contact any other parts.
• Water pump cannot be disassembled and should be replaced as a unit.
4. Remove water pump housing with the following procedure:
a. Remove exhaust manifold cover. Refer to EM-33, "Exploded View".
b. Remove oil level gauge and oil level gauge guide. Refer to EM-35, "Exploded View".
CAUTION:
Plug the oil level gauge guide opening to prevent oil pan from entering foreign materials.
c. Remove mounting bolts for water pipe.
d. Remove water pump housing.
5. Remove exhaust manifold and three way catalyst assembly. Refer to EM-33, "Exploded View".
6. Remove water pipe.
2.) I've read the hoses are a common source of headache on Nissans, but my leak appears to be from the seal/gasket on the water pump not from a hose. The leak shows on the under side bolt hole. Is this a common seal that goes out?
There are three gaskets and one oring:
I cannot comment on this being common or not. I would personally look into the Altima/Sentra forums as well for feedback. They may have more long-term results (since the Rogue only came out in 2008, not sure when the 2.5L was redesigned last).
3.) Given that I have might have to replace the seal, is the water pump itself a likely culprit, and should also be replaced?
I would personally, if the price of an OEM pump is reasonable, replace the water pump because you have it taken off. It is a part that will eventually fail, and you have now realistically increased the time before it fails by swapping it out. Many would leave it in, and if the cost of the part is high I would too, but swapping it out now just gives you more usable life.
So...it depends on whether being proactive fits with your plans for the vehicle (maybe you're selling in a year) or not.
This is the first Nissan I've owned and I'm really disappointed that I've already developed an issue like this when I'm a whole 4,000 miles out of warranty.

This is not covered by the 5 year powertrain warranty? (Or is that Canada only) For instance, GM considers the water pump as "covered" under their powertrain warranty:
http://www.gmc.com/owners/warranty.html