Green MSP elected Holyrood presiding officer after party co-leader backs end of monarchy