I've already sat the wife in the car and poured water over it, then she pointed out that I was supposed to have the top up.
Only joking, she did see a small amount of water coming in past one of the rubber seals between the seal and metal frame of the hood so I've pumped some silicon into the join to try and solve it. Hopefully test it out again this weekend. Itdoesn't look a bad enough leak to have soaked the carpets as much as they were though.
I've also noticed that the piece of plastic trim across the base of the windscreen (the piece that the windscreen wipers poke though) has a crack in it and wondered if water could be getting in through there somehow. The crack is directly above the passenger side footwell. My plan is to replace that piece of trim to see if that helps.
Anyway thanks for the advice and I will look out for you around Reading and maybe even see you at Beaulieu.