Most of Canada is awash with waterfowl but some areas are more awash than others.
I do not live anywhere near Calgary (I'm in Toronto) but I have been there lots of times and it's a great place with great people. And fom a hunting perspective, the area around there is amongst the best. Any of the 3 prarie provinces and you will see plenty of ducks and geese - more than elsewhere in Canada. So I'd say pick whatever city in the praries (the provinces of Alberta, Saskatewan, and Manitoba if they didn't teach that in Scotland
) which is best suited to you, what you want in a city, what jobs are available, etc.
Calgary is the most cosmopolitan of the prarie cities, the largest of them, and has the best air connections as well. Not to mention lowest income taxes, no provincial sales tax, cheap gas, etc. The downside is that real estate is $$$ due to the oil boom. If you are coming on an ex-patriot package and your employer will foot a cost of living allowence, no problem. If not, the real estate there is about as epensive as Toronto and Vancouver. It's not London, UK bad but by Canadian standards housing in Calgary is 2 or 3 time more expensive than other prarie cities like Regina, Saskatoon, or Winnipeg.
Within a reasonable drive from Calgary you have ducks and geese, deer, Elk, a few upland bird species, some of the best trout fishing, etc. Not to mention being a 45 minute drive from the staggeringly beautiful Rocky Mountains.