Generally you don’t need anything but the original 1998 Unreal patched to one of the latest versions (patches 226f or 227i) to play these maps unless otherwise specified. For some, you might need Unreal Tournament (1999). If you are asking about a specific campaign, please name it.
You don’t need internet connection if you want to play alone. Hope this helps.