Mainly this is due to low light. During daytime there is enough light and you get a good picture quality. One of the best solutions is to change the lens of your CCTV camera. Use an IR corrected objective lens. This will make the night vision clearer.
Any more help needed, please let me know.