I'm looking for a pump that can be used for Tiffany's plants, to empty water out of a tray. However, it should be able to tolerate a decent amount of air coming through the hose, because there will be times that the intake tube isn't under water.

And maybe it should be able to handle a little dirt too.