A council has blocked an application to build six giant wind turbines in a Yorkshire Wolds beauty spot immortalised by the late David Hockney after a fierce local row