A climate commissioner for Northern Ireland will be appointed, despite the deputy First Minister saying one is not needed.