Smoking the water pipe is Haram (prohibited). It is a sin if you repair it for him, as Allah (Exalted be He) says:
...but do not help one another in sin and transgression.
(Part No. 22; Page No. 147) May Allah grant us success. May peace and blessings be upon our Prophet Muhammad, his family, and Companions.