A council which declared a climate state of emergency was paid by an oil company in its latest bid for long-term production.