[ShredKazoo]

As the climate warms, we can expect more flooding in low-lying coastal areas.

What if someone created a mobile climate response team that dealt with floodwaters by injecting them into the air as aerosols? Kill 2 birds with one stone.

It's even possible that you could do it as a for-profit, by charging municipalities for the service. (For profit means more scaleable, easier to get capital)

I don't know what sort of approach might be feasible here. Could do something really imaginative like an inflatable tower with tubes running along it and pumps at the bottom. Or drones as described in the OP.