A long-anticipated scenic overlook in Rochester, where residents can view the Cocheco River, is finally about to become reality.