The UK Budget needs to invest in services and infrastructure in order to bring about an end to austerity, the Scottish finance secretary says.