Lincolnshire Lakes 'not dead in the water' says council leader as Scunthorpe United pull out of stadium plans