In general, you won't need Wi-Fi or cellular connectivity when you draw. You're all set as long as you have the drawing apps installed on your Apple iPad.
You can download your drawing inspiration beforehand, so you don't have to worry about having connectivity issues later on.
Nonetheless, having Wi-Fi or cellular connectivity is very helpful, especially for sending files to other people.