iproute is mostly correct. I assume that all users on the 192.0.0.x/24 subnet can access the Internet fine. You need to configure a static route on your DSL router (192.0.0.150/24). The static route should state that to reach 192.0.1.0/24 network, the gateway should be 192.0.0.1 (Local Netopia). Local Netopia should already have a route to Remote Netopia so no further static route is required on Local Netopia. Just make sure Local Netopia's default gateway is 192.0.0.150. Finally on Remote Netopia make sure the default gateway is 192.0.0.1 so that any traffic destined for the Internet from the 192.0.1.0/24 network will route to your Local network.
One final note, theDaver makes an excellent point. I assume you have a private network behind NAT with your DSL router assigned a single public IP address. You may want to consider redesigning your network as theDaver mentions to avoid any possibility of you not being able to route to sites within the 192.0.0.0/24 and 192.0.1.0/24 subnets.