A surface and ground‐water integrated investigation of streamflow drying up in semi‐arid regions