Yes, it's in Moncton city limits. And yes it's within sight of our famous Magnetic Hill. Its name is Casino New Brunswick and its web site is www.casinonb.ca. And its theme is .... lighthouses.

The casino complex will be comprised of three separate and distinct buildings - a hotel, the Palladium (a multifunction entertainment and convention centre), and the casino. The buildings will be connected by an interior corridor that allows internal access to all three buildings.

(Here is a Google map link)