Ive seen quite a few (mainly foreign) motorhomes overnight parking on the road infront of the Radisson hotel.
Also, the rowing club has a small campsite, but on the road that leads to it there are again free parking spaces that I would imagine you wont have any problem overnighting in, including the small 'carpark' at the Durham city cricket club less than 100m from the rowing club.