Oil and gas drilling site in AONB refused against officers’ advice