Efficient utilization of photogenerated charge carriers to realize photocatalytic solar fuel production and oxidative chemical synthesis is a challenging task. Herein, a conventional amidation reaction route is adopted to successfully construct a novel composite photocatalyst composed of a Ni(II)-terpyridine complex with carboxyl groups grafted on CdS nanorods (labeled as CdS@Ni(terpyC)2). Experimental results have unequivocally revealed that the as-fabricated composite catalyst exhibited a remarkable enhancement in photocatalytic activity for the dehydrogenation of benzyl alcohol under visible light, demonstrating superior hydrogen evolution efficiency and benzaldehyde selectivity, surpassing both pristine CdS and the blend of CdS and Ni(terpyC)2. The carrier dynamics study demonstrated that the Ni(terpyC)2 on the surface of CdS could quickly extract the photogenerated electrons of CdS, which reduced the carrier recombination efficiency, further improving the photocatalytic activity of the catalyst. This work illustrates the effect of surface active site engineering on photocatalysis and is expected to shed substantial inspiration on future surface modulation and design of semiconductor photocatalysts.