Gfrktyl

A scenario in the far future -- The moon has been successfully terraformed. All problems have been worked-out, from flinging volatiles into collision course with the moon, up to creating and retaining a stable and breathable atmosphere. With state-of-the art technology, an artificial magnetic field shields the atmosphere from solar winds, and additional shielding retains it despite the moon's low gravity.

While deploying lunar orbiters, astronomers had to take mascons into account. The mascons create fluctuations in the surface gravity. Along with the moon's low gravity, the changes are sufficient to disturb lunar orbiters and kick them out of orbit, if the right orbit was not chosen. Here is a map of gravitational distribution affected by mascons. (View source here, from the GRAIL mission). I did not find information on how noticeable the anomaly would be to an astronaut standing on the surface.

The question -- One (among many) of those anomalies happens to be under the ocean's floor. Given the relatively high anomalies (did not find the exact figure in percentage compared to average), would the anomaly cause some water to "pile-up" and create a "hill" noticeable from some distance? Would that be a significant "curve" of the water's surface to make a tourist attractions for colonists and visitors alike?

This article gives us some useful numbers:

The mascons' gravitational anomaly is so great—half a percent—that it actually would be measurable to astronauts on the lunar surface. "If you were standing at the edge of one of the maria, a plumb bob would hang about a third of a degree off vertical, pointing toward the mascon," Konopliv says.

So the "water hill" would essentially be a plateau, hundreds of kilometers in diameter, with a slope of a third of a degree at the edges. It wouldn't be prominent enough to be noticeable, or distinguishable from the normal curvature of the Moon (where 1/3 degree is equivalent to 10 km).

Kicking satellites out of orbit might seem impressive, but keep in mind that this happens over time, after the satellites passes over the mascons many times and is nudged a tiny bit each time. And an orbit is a rather delicate thing. The local effects of a mascon are not really that impressive.

What you ask already happens on Earth, where gravitational anomalies influence the ocean level.

These hills and valleys are not visible to the naked eyes, but can be detected by satellites.

The first attempts of measuring G were actually done measuring gravitational anomalies close to large mountains.

I guess the same would happen on the Moon. There would be hills where gravity is lower than average and valleys where the gravity is higher than average, but they would hardly be noticeable to the naked eyes. Or even be perceived by the unaided human body.

Here's a similar question which has an answer talking about the relative field strengths of Mascons compared to the regular surface gravity of the moon.

The short answer is that mascons produce tiny fractions of a percent of difference and you wouldn't notice the difference as you walked through them.

I would not expect that a Mascon would produce enough effect over a small enough area to be noticeable. Gravity as a force has a pretty shallow dropoff curve compared to the other fundamental forces, the International Space Station for example still receives about 89% of normal surface gravity at 250 miles up.