It definitely does not have to be federally-funded. Lots of West Coast cities, in the US, are beyond flush, and mixed-income housing is a good investment, especially when you, as a government, have various advantages over private businesses (no property tax, reduced borrowing rate, and streamlined permitting).

Portland, Oregon's homeless services budget was $35m last year and none of it went to new public housing.