Canyon Lake, which is over 40 miles north of San Antonio, is at the lowest it's been in decades due to the region's extreme drought