I don't want dwarf fortress to be half about dealing with shit. which is exactly what this suggestion would do to the game. (seeing goonstation players in here honestly doesn't reinforce the 'for' side of the argument.)
I don't see how goonstation players affect your game... unless you are one yourself.
For example, you designate a defecation zone. If it's in a river, preferably downstream your drinking zone. If it's in the woods, you might need to zone a new one once every five years if your population is large. You might have more dwarves annoyed by flies. But that's about it: no more than you need to do to to provide water, just in the reverse, and similarly with the option to dig a well, but in the reverse. Most importantly, you'd get the option to build a compost pile building, that spontaneously deconstructs into a few items of fertilizer after a four or five months (automated like render fat would be nice). It really wouldn't be much more than this in a basic form. I'd prefer to add the liquid, for the tanner and various chemical applications, too.
goonstation thing was a poke at the largest community of assholes in SS13, who singlehandedly ruined it, roughly akin to minecraft griefers.
but ANYWAYS, it is not so much i would not like the feature, but i want it AFTER other inside threats are more fleshed out.
with current DF you would have. 3% food, 7% nobles 10% happiness, 30% engineering fuckups, 50% shit to clean up as your internal conflicts.
if more stuff was added, and other features re-balanced you would get a situation where this idea becomes a wonderful implementation.
however, I would prefer it be implemented in a slightly less intrusive manner, as the ideas in this thread would make it a main focus of your fortress. realistic? yes. fun? no.