A decorated retired Marine whose career as a sniper was derailed by a video which showed him urinating on the corpses of Taliban fighters in Afghanistan has died, his lawyer has said.