I am very happy with how
Fringe Tree (Chionanthus virginicus) has done in my yard. We have lots of clay, and while I don't know that it 'soaks up' water, we have one growing happily in a spot that gets standing water for a few months in the spring, so it at least tolerates it. It has unique flowers, and the leaves are consistently attractive, even when other things start looking shabby in the summer. Unfortunately, you have to plant a male and a female to get fruit set, which the birds would like best and I didn't luck into that, but am still very happy with it. They are a bit hard to find sources for, which I don't understand, I think they should be much more widely planted.
I think the butterfly forum (
https://garden.org/forums/view... ) has links in their sidebar listing plants that are hosts for specific butterflies and birds.
Edit: The Amelanchier family is also very nice for wildlife. Early nectar and fruit for birds. I forget how they do in wet soil though.