A new Scottish National Party-Scottish Green Party deal will also see an extra £45m funding going to low carbon projects