If you can get it, the Hotel San Jose is a great place to stay at. It's right on South Congress near tons of stores/restaurants. I couldn't really tell you about any other places at or near downtown cause I haven't tried them.
As for nightlife...it depends on what you want. I usually avoid 6th Street, but if you're not a local, you probably need to go there just to see what it's like. There's about 100 bars that run the gamut from jazz, cover bands, original music, Esther's Follys (comedy skits), and frat boy hang outs.
If you're into live music, Red River from 6th St to 10th St has a lot of venues from Emo's to Stubb's BBQ with about a dozen places in between.
If you wanna relax with a nice beer or glass of wine, maybe some tapas or a steak, the Warehouse District is really nice. That's mostly centered around Colorado and 4th Streets. Cedar Street bar has a nice outdoor courtyard that's tucked in between two restaurants, but usually they have cover "bands" that blast loud, R&B music (they used to play jazz which was much cooler IMHO).
The 2nd Street District just a few blocks away at 2nd and Lavaca is starting to click with activity. There's some shops, restaurants, a cafe and a wine bar, but little of those are local, and most are expensive.
Finally, there's the West End which is 6th Street west of Guadalupe. There's a handful of bars/restaurants with outdoor patios where you can relax and people watch.
Hope you have a great time in our fair city.