Terrific pano, Leon! Gives one a perfect overview.
I grew up about 25-minutes away from Niagara Falls. We now live just over an hour away.
Previous posters are right, you really need to be here on the Canadian side to get the best pictures of the American Falls and, to the minds of many, the more picturesque Canadian (Horseshoe) Falls.
We really should visit more often. The photo opportunities are everywhere, not only along the river but in the Clifton Hill/Falls Avenue entertainment district, Indoor Waterpark, Fallsview Casino, Skylon Tower, garden areas, etc.
Great spot for people/street shots...
Water doesn't need to be a problem, unless you get so close that the mist can't be avoided. In many cases, it all depends on which way the wind is blowing. Here are two shots, the first from inside, showing people standing right beside the brink and they're not getting wet.
If you're taking pics close to the Falls, you can see where the spray is falling because the street and sidewalk will be wet.
Depending on how much time you have, you can also venture north on the Canadian side to take in the Niagara Gorge/Whirlpool, Queenston and a final stop at Niagara-On-The-Lake, with its many historical homes, churches and shops.
It's a nice drive along the Niagara Parkway. I should also mention that gets you into Ontario's wine country.
One consideration: if you're driving a rental car, let them know you'll be taking it into Canada, have them show that in the agreement and carry it with you. That avoids any problems at the border or with the provider.
If you're not used to the camera, just put it on Auto or P and you should get some great shots.
Enjoy your trip!
mike