A man arrested over the murder of two nuns at their Mississippi home has confessed to the killings, a sheriff said.