This is not something that DNS alone can do. As pointed out above, your second DNS box is not a slave if it doesn't have identical data to the master. With 2 ISPs, you can create 2 of any record (2 A records, 2 www records), but if ISP 1 goes down, NS2 will still give out ISP 1 addresses 50% of the time, and those will fail.
To get what you are looking for, you'd need to have something that can test each link, and modify your DNS info so that if one link goes down, it only gives out info for the link that is up. You could do it simply by modifying tools like nagios to activate scripts to change the DNS info.
If you need
really super availability, you should look at something like
http://linux-ha.org/ which is something like a software load balancer. A hardware load balancer is also excellent, but also extremely expensive.
Also, for you to do a "simple" DNS correction, you have to b e sure your network has an architecture that allows it to still function with one link down.
Peace,
JimBass