A three-year collective bargaining agreement between a registered nurses union and Cabell Huntington Hospital will go into effect Sunday, union representatives said.