I live about 8 miles away from donny, barnsley and rotherham and agree with ton that for the mtb the area is poor however there are some decent bridleways / footpaths that you can link together.
On the road bike i usually head towards boothferry bridge via sykehouse on relatively quiet (and flat 🙂 roads