Dirty water and dirt is actually pretty easy to mostly automate early game with transfer nodes.
Compost material in a chest, transfer node out of that into top of barrel, transfer node from bottom of barrel into a chest, slowly filling with dirt.
For clean water I just grab some dirt, mix...