Best (short) hike with best view is Cedar Bluff Nature Trail. Less than a mile and best view of the valley.
You can also hike along the river spillway with the Friends Loop trail. Also a great place to short tube (byo tube). Oct may be too cool because the water is COLD.
For long tubes and canoe trips, you can hook up with an outfitter in the park. The lower mountain fork river is pretty great for canoeing - very mild rapids and cool water.
Someone mentioned zip lines - there is also a great golf course, putt putt, bowling, maze for the kids, and a petting zoo. There is plenty of shopping as well.
Food - Grateful Head (pizza) is a must, Shuck Me (seafood), and the Saloon are all great.
Night life - the saloon has a stage now, so they often have concerts on weekends.
There is also the casino….