How do I tell an iOS device there's no internet connection on the Wifi?
You should define a STATIC address for the WiFi/LAN. (define an correct netmask, and dont enter any router/gateway address ). (see the static tab in the @Michiel's screenshot.)

When you done, you can access the computers on WiFi network and you will access the rest of the Internet via 3G.

This is what you looking for?