What kayak (model or even type) would be best suited for a long river tour?

I want to take a long term (2 week) solo trip down the Guadalupe river. From Hunt Texas to Austin. I plan to take all gear with me and eat mostly military MREs. The river doesn't have too many rapids but it definitely has some exceptionally shallow parts and some snaking and winding turns. I've tried this trip before in a Pelican Castaway Deluxe and it worked well but didn't survive the trip. Even being careful the shallow bits ate through the hull only halfway though. Of course money is always a factor and value is important. This is not a question over SHOULD I attempt this trip again, or HOW to attempt this trip; only in what vessel this community recommends. Thank you.