'Lot of grief' as acute water shortages threaten drought-hit NSW towns