Natural gas production from shale enjoys widespread backing across the UK, with more than three times as many supporting production as opposing, according to a new survey.