I'm in the exact same boat... here's what I have found out and who I have talked to ....
1. talking with DU... I find it easier to call their number 1-866479-3825 and they will give you the number of the one in your area if you not in the edmonton area. They have land around certain lakes/ponds/sloughs mostly only foot access no motorboats allowed ( kayaks rafts anything MAN powered). If you are in the Calgary south area talk to Ashley at DU 403-465-3310 ( cell ) or (office) 403-476-1870
2. The Alberta Conservation Assoc. website is helpful
http://www.albertadiscoverguide.com/search.cfm as it will show you different areas that you can hunt specifically.
3. I have talked with AHEIA, one of their instructors ( actually sat down in his office) about where I can and can't hunt as my question was what lakes can I go and hunt on with a boat / motor ( like I used to in Ontario ) and I was told that any lake that has boat launch access I can hunt on as long as I don't need permission to cross private land to get to the boat launch ( which then you ask permission)... with that being said if there is a recreational area (example a campground) on the lake you have to be a certain distance from it ( which I don't remember sorry ) but its more of a common sense thing a good 4-500 yards is sufficient I would think but I will call and ask if I'm going to a lake I want to hunt and set up near a campground.. ( which would probably never happen.)
With all this in mind - I have tried to do my due diligence ahead of time and I have gone out to scout area's during the daylight hours prior to my hunts, and have found some areas are too far of a walk to carry guns ammo decoys and maybe a snack.... and I have also fallen into a mud spring up to my armpits ( didn't see that coming)
I hope this helps!