More than two-thirds of people would rather have a wind turbine than a shale gas well near their home, according to a new opinion poll published on Tuesday.