I think it depends on what you mean by 'success'.
If you dig a hole, it will either fill with water of its own accord, or can be made to do so.
However, if you then put ducks in it, IME it will become disgusting pretty quickly unless it has a through-flow.
Can you think creatively about the water source? We had a patch of ground that was forever boggy, so we had a pond dug at the same time as we improved the drainage in the rest of the field. The new drains lead into the pond, so 80% of the time, there is a through flow. I've also seen a small pond which achieved through flow by routing the barn gutters into it so that it then overflowed into a drain. That gave a decent slosh through of water every time it rained, and kept things tolerable most of the time.