Microscopic treatment of energy dissipation and decoherence via many-body Lindblad superoperators