We stayed in
Bentsen Palm Village in Mission in March, 2007. It was a really nice resort with beautiful landscaping, a pool, and a woodworking shop. There is a state park right next to the RV park with excellent birding.
I don't know about weekly rates, but the monthly rates were below $500. Their most popular months seem to be Dec through March, so you should be able to get in for April.