I can help with the native fishes. There are few species that's suited for both pond and aquarium life.
Minnows group:
Golden Shiner
Red Rosy Minnows
Red bellied Dace
Central Stoneroller
Finescale Dace
Pearl Dace
Bitterling (not native)
Fathead Minnow
Few species of shiners or chub.
Catfish group:
Stonecat
Madtom
Single bullhead of any species
Sunfish Group:
Bluespotted Sunfish
Blackbanded
Banded
Bantam
Dollar
Orangespotted
Northern Longear
Mud
Green
Pumpkinseed
Bluegill
Rock Bass
No Black Bass!
Yellow Perch
Flier
Spotted Sunfish
Killifish group:
Bluefin killifish
Blackspotted topminnows
Golden topminnow
Northern Studfish
Mummichog
Blackstriped topminnows
Redfaced topminnow
Banded
Plain
Zebra killifish
Lots of killifish/topminnow species
Flagfish
Rainwater
Sheepshead
Pygmy
Least killifish
Mosquitofish
Sailfin Molly
Others group:
Redfin pickerel
Grass pickerel
Pirate Perch
Mudminnows
Brook stickleback
Swamp darters
There are so many different species around in North America but the species I posted are most common kept by Native fish keepers. Tell us what you want from the list. You can even breed some natives such as bluespotted sunfish as you can put them in the summer and fished them out by fall (you will find some extras) just make sure you get suitable tank for some species (pickerels can do well in 40gal breeder tank while least killifish/pygmy killifish do best in planted 10gal tank etc). Sunfish may be aggressive, think them as cichlids so 30gal for smaller species while 55gal for bigger species (bluegill, rock bass, pumpkinseed and green sunfish but beware sometimes they are better in tank singly). A single bullhead do well in 75 gal tank. Most of the native species do well in 10 to 30gal tanks indoor during cold time months (fall, winter and early spring)