Water seepage around the water main pipe’s underground entry hole thru concrete foundation

Before going through the waterproofing hassle, do check your gutters again. Even though it's the gable end, you want to make sure your downspouts elsewhere are carrying the water away from the foundation as far as they can.

Then, check the slope of the ground. Is it sufficiently sloping AWAY from the foundation? If not, fix that too.

After that, if you still have issues, if you're going to be digging out the foundation, you definitely want to consider a drain tile system while you're down there. That typically has to go near the footer, so be careful doing that (you'll likely want to consult an expert before digging out the footer.)

At that point, the typical waterproofing system is some form of a rubber membrane then covered with dimple-board. The dimple board protects the membrane from the backfill and also acts as a drainage plane into the drain tile system.

If you don't have gutters and the grading around your house isn't sloped away, I'd start there. It's relatively cheap to do and will eliminate most problems. It's also nice, if you have a door at the bottom of a roof edge, to not enter under a waterfall.

Once you've done that (or if it's not possible to fix the grading) and the foundation is still wicking water, then an exterior water proofing system and french drain makes sense. This involves a painted on sealer, a free draining membrane that's attached to the wall (this gives a direct path for any moisture that reaches the wall to run directly down to the drainage pipe), and a perforated drainage pipe running around the perimeter of the foundation that drains well away from the house. If a system like this isn't installed during initial construction, it's often left to a last resort because of the expense and labor of removing any landscaping and soil that is against the foundation.