Hello again Allan,
I stand by my method, used on several occasions by my self and passed on successfully to others.
I share your concerns about instability but the additional momentum of the water in the barrel is very small in comparison to whole caravan. And again I stress that if an empty caravan were to be unduly stressed by a 32Kg mass at the rear, then there would be cause for concern about the outfit even without the additional ballast.
Of course it has to be done with due care, and it is a last resort when other normal ballast items are unavailable.
Now specifically for Harry's situation, if you read his last reply, he admits there were none gas items in the gas bottle locker and by removing them the nose load was reduced - no surprise. Consequently if he were to use my method he would not need 30kg as you suggest.
However, containers like an Aquaroll are available in two sizes, I have only ever used the small 29L version typically If it were full, there would be no slop, so again provided it is secured as I have done in the past, there is no more danger from it than any other heavy item in the caravan.
As for securing the barrel, I have used different methods depending on the particular caravan in question, ranging from providing anchorage points for webbing straps to being braced in the toilet compartment or in bedding locker, and finally retained by awnings and poles in the rear foot well.
It is a valid method, but it is a personal matter if you or others wish to use it or not.