For motorhomers there is an Aire de Service, Camping Car, in Sete itself which is about as central as you can get and where you can stay overnight whilst visiting.
If you want a campsite then the nearest is probably Les Castellas, and this website might help you find information about public transport.Useful information about Sete