The nv driver should work fine. The onboard video is a garden variety Geforce2 MX chip. I doubt there are any optimized drivers for the north/south bridge motherboard chips or drivers for the onboard sound, but the default motherboard drivers should do fine, and you can always toss in a PCI sound card and disable the onboard sound.
EDIT -- Upon further inspection, it seems the on-board, though essentially a Geforce2 MX core, does differ in its memory architecture from the standard MX. The nv driver should work, if it is able to recognize that the core is a Geforce2 ... not sure if it would be able to recognize it correctly though.
Upon further, further investigation, the answer to the question is: anything older than the brand new release of
XFree86 4.2.0 does not natively support the nforce graphics core. X 4.2.0 just came out within the last couple days though, so there are very few biaries available yet (looks like the only binaries posted so far are for BSD) so you'll have to either wait for Linux binaries to be released or compile from source.