ADH deficiency can lead to a condition known as diabetes insipidus, characterized by excessive urination and thirst. Histologically, the kidney tissues in individuals with diabetes insipidus show a lack of response to ADH, with the collecting ducts and distal convoluted tubules failing to reabsorb water effectively.