The report says 800 jobs could be created over 15 years through green investment at the site of Scotland's only oil refinery.