Scottish Water says storage levels at some sites are at 66% amid one of the driest summers in 160 years.