Definitely stay in downtown Greenville.
I looked at Google maps to refresh my memory - if you want to be RIIIIIGHT on the river, book at either Embassy Suites or the Hampton Inn. The Embassy Suites is probably better, as it has a rooftop bar called Up on the Roof (there are several excellent...