A former Waterford county council worker has been sentenced to 10 years for the sexual abuse and rape of two sisters and a third woman over the course of 12 years.