Weather turns pleasant after light rain in Delhi-NCR