Decreased AVP release (neurogenic - i.e. due to alcohol intoxication or tumour) or decreased renal sensitivity to AVP (nephrogenic, i.e. by mutation of V2 receptor or AQP) leads to diabetes insipidus, a condition featuring hypernatremia (increased blood sodium concentration), polyuria (excess urine production), and polydipsia (thirst).
SIADH in turn can be caused by a number of problems.