Switch labs.waterdata to api.water

The labs.waterdata.usgs.gov endpoints are being sunset and replaced by api.water.usgs.gov. Update the URLs and test all the notebooks and unit tests.