Does supportive supervision enhance community health worker motivation? A mixed-methods study in four African countries