Towards sustainable livelihoods through indigenous knowledge and water use security: insights from small-scale irrigation schemes in Limpopo province