I have a history of black thumb too, but you will want pond plants. The plant and ignore kind.
Water lillies: plant where they will get lots of sun, in the biggest container you can, a long shallow wide container filled with pure clay no additives cat litter, the cheap stuff. If your water doesn’t leave rust colored stains, you might add a bit of steel wool or something to it, there’s threads of advice on here. And just in case, find a way to cover the top with fish proof wire like chicken wire, for later on.
Submerged plants: there are threads on them. In addition to pulling waste from the water, they help oxygenate it.
Cattails, rushes, other marginals: they will grow well in pots on the shelves, just barely cover the pots in water. Some iris can grow like that, others may need to be just above water line, but roots stay wet.
Plants use fish waste to grow, thus helping keep water safe for fish, reducing need for water changes, and reduce the algae. Otherwise you’ll be on here in no time trying to figure out how to clear the pea soup water.