Loctite came yesterday so I applied it round the outside of the ferrule and on the end. When applying to the end I did it sparsely so that it doesn't end up blocking the passageway. Twisted it into place and put a bit of the glue round the outside of the ferrule where it meets the carb for good measure.
Left to set for 24hours.
Put the pipe back in this evening, put everything back together, yet it still leaks.
With some pliers I've managed to remove the ferrule again, check the passage is clear and try again. I guess I need to leave it to set longer.