you can get a mains connection for your aquaroll as long as its the 40 litre bottle it goes into the side of the bottle you'll also need a longer piece of hose with a y connector piece for your waste to go directly into the drain its the only pitches we use
------------- Autism= Awesome, unique ,Special, talented, Intelligent, Smart and Mysterious.
It will depend whether your caravan allows direct connection to the mains to fill an onboard tank. If not the solution suggested by Jo is likely the best option. When I am on a pitch with a water point I just use my hose to fill the aqauroll.
The Aquaroll type connection is a good choice in as much that if there is high pressure, like you encounter on some sites abroad, should anything go wrong the flood is on the outside of the van.