SNP ministers have announced wood burning stoves will no longer be banned in new build homes in a major U-turn.