I've done two small fish ponds using heavy duty rigid plastic liners expecting only the fish (koi and shubunkin) would enjoy it. We live less than ~10 miles/~15 km from downtown Boston.
We were surprised to see the second pond, which is next to the north side of our basement and on a small hill, gets all kinds of animals and birds coming to drink. Racoons, possum, fox, squirrels, and many types of small birds. Without fail, one or two tree frogs find it every summer and settle in on the water plant we put out there (taro) in a semi-submerged pot.
The frogs disappear in the early autumn. Before the first hard frost, we bring the taro plant inside in a bucket, and place it next to a sunny window for the next 5 or 6 months. By mid-December the pond freezes over except where we have a small pump running. The fish go dormant at the bottom, under the ice.
Then in spring it starts back up again. The ice melts, the fish come back to life, and the animals return to drink. We put the taro plant back out, and once again the pond is the center of life in our side yard.
Images: