A search is under way for an 11-year-old boy who went missing after being seen entering a river in South Yorkshire.