ADH affects the collecting ducts. It's the same thing as vasopressin. It allows the lumen to be more permeable to water by adding in more aquaporins. Thus water is reabsorbed into the efferent arteries and not expelled through the urine.
Edit: It also adds them in the distal convoluted tubule btw.