State regulators on Wednesday gave final approval to the sale of Connecticut’s largest water company.