One of the things tested is the specific gravity. If you add water to your specimen, the specific gravity will be below the normal range and you will be caught. The drug test itself may still detect drugs in your specimen, so you will be shown to be dishonest along with being a drug abuser.
It tests as watered down urine. Whatever is in it before you add the water will still be there after you add the water.