Good, small 1000 ltr bowsers are like hens teeth unless you buy new.
A lot of helicopter companies use them for away events, you could try some of them and see if any are for sale, though they would generally have been used for AVTUR and I don't know how much of a hassle it would be to convert it across.