Neil Gray said he would instead vote by proxy and will abstain given the Scottish Government's position