I've lived in the Rogue Valley for the last 30 years and agree that Valley of the Rogue is probably the most centrally located public campground with hosts that is on the river. Emigrant Lake is a nice county park however it puts you quite a distance from the river, but is a great choice if you want to spend some time in Ashland at OSF or other theaters. Some other suggestions depending where on the Rogue you plan to fish (listed from Northeast to West)... these all have hosts, all with at least water and electric except Farewell Bend.)
Farewell Bend near Union Creek (USFS)
Joseph Stewart State Park between Trail and Prospect (Oregon State Park)
Rogue Elk County Park near Trail (Jackson County)
Valley of The Rogue State Park (Oregon State Park)
Indian Mary County Park below Merlin (Josephine County Parks)
There are a number of smaller federal and county campgrounds nearby but not all have hosts.
If you'd like more information feel free to PM me.