Nova nucleosynthesis and Galactic evolution of the CNO isotopes