A former Scotland rugby captain has pledged to display the “drive and determination” he had on the pitch towards tackling the country’s housing crisis.