If you went with a trout, SMB, YP pond, you would need some Golden Shiners as a main forage base along with native crayfish which could be sourced in local cool water creeks along with plenty of rock for the craw habitat and SMB spawning...given enough flow and some creek gravel, you might even pull off a trout spawn. If going with a YP/SMB option, you would need some walleye to control the YP.
Many possibilities to consider...all fun!!