Previous investigations into lithology-driven weathering processes have largely emphasized large-scale spatial assessments, while studies targeting small watershed scales remain scarce. This study investigated two adjacent watersheds (Chengjia: CJ; Datan: DT) under comparable climatic conditions in Guangdong, China, using hydrochemistry and stable carbon isotopes. The CJ watershed exhibited low-TDS (20–66 mg/L) HCO3-Na·Ca-type waters dominated by silicate weathering, whereas the DT watershed displayed high-TDS (70–278 mg/L) HCO3-Ca-type waters, indicative of mixed carbonate–silicate weathering. Results of carbon isotope composition of dissolved inorganic carbon confirmed that H2CO3-driven weathering was the dominant mechanism in both watersheds. In the CJ watershed, 79.5% of dissolved cations in surface water originated from silicate weathering, yielding a CO2 consumption rate (CCR) of 0.28 × 106 mol/km2/yr, while carbonate weathering was negligible. Conversely, in the DT watershed, 86.4% of dissolved cations were derived from carbonate weathering, yielding a CCR of 1.94 × 106 mol/km2/yr, whereas silicate weathering contributed only 10.3% of cations with a CCR of 0.23 × 106 mol/km2/yr. The chemical weathering rate of carbonate can be up to 10 times that of silicate, resulting in a larger CCR. This study demonstrated the key impact of lithology on hydrochemical characteristics and CO2 consumption at small watershed scales.