One pioneering Scottish affordable housing project shows that with a little resolve, adversity can lead to triumph.