I don't think they have much effect on a well constructed pond with adequate watershed.

Several years ago my parents planted several dozen around one of the ponds on their farm. (The pond is roughly an acre, but it does have quite a bit of watershed) Some of the trees are starting to get pretty big now and there hasn't been any difference in water levels since they were planted.

Eric