The host galaxies of double compact objects merging in the local Universe