Two weeks there at the height of the tourist season doesn't seem like a great idea. It gets packed out. I'd be more inclined to rent an apartment nearby and make a couple of day trips there. That said, I stayed here a few years ago and it was very nice but a little on the pricey side, if I recall. [broken link removed]
Narbonne is a lovely little town. Home of Charles Trenet. Also has some very interesting Roman ruins. I stayed in this place and it was absolutely beautiful and surprisingly cheap. [broken link removed].
Beziers is a depressing little town.