Sustainability of community-managed small town and rural water systems in northern Ghana: lessons from Upper West Region