Hi Farmer
Im not sure of a weekend holiday on board a submarine,
But there are lots of Subs moored in Europe where you can visit and go onboard.
I was on one in Stockholm, an old Russian Cold war sub - its really intresting, but it will only take an hour or so.
I think the UK navy have a submarine base in Portsmouth where there are lots of exibits aswell.