Reservoirs across Scotland fell to their lowest levels in decades as the country experienced its driest period since the 1960s.