Yes, I've got a 1/4 acre pond in my backyard I worked on last year. Then again I live on 10 acres. It's got fish, frogs & mud turtles in it right now. I guess I did okay as I have seen a few Canadian geese on it lately and I've got a Blue Herron that visits. I have a neighbor who put in 2 large cement ponds for the Canadian geese.
I just finished constructing my duck pen, and that will soon have a pond in it. I'm going to use a regular formed pond you get at Lowes, Home Depot or your local nursery. That way they always have a pond. Outside of the pen I am sectioning off an area I call the "Flock Park" and it also will have a pond, but I am using a kiddy pool and cement blocks you use to surrond trees or build retaining walls with for that one.