Plans for a "mini fracking" site in Burniston near Scarborough have been rejected by North Yorkshire Council following local outcry.