I’m a big fan of Red Shiners /Red Horse Minnows. Cyprinella lutrensis
Longear sunfish are good if you want a single larger fish. You have to catch one young, they’re too timid if caught as adults, but they make great ‘wet pets’.
We have multiple species of shiners and darters that make great aquarium fish if you set up a long tank with higher flow than is usual.