The Dia Center is a great little museum for contemporary [right now!] art in New York City. You can find more information about their upstate branch here:

http://www.diabeacon.org/bindex.html