Hi JBray81
I'm not sure if you got anywhere in researching your grandfathers time at Scapa Flow.
I've been researching my father's ship HMS Bandit, which was also at Scapa on the night of the 13/14th October during the tragic loss of Royal Oak.
You've probably found out that each warship was allocated a 'drifter' which would provide basic services to the ship - delivery of equipment, people, mail etc. Before the war they were small fishing vessels that were 'pressed' into service by the Royal Navy.
On the night of the 13/14th there were 7 drifters at Scapa - Horizon, Indian Summer, Fumarole, Harmatta, Sheen, Shower and DaisyII. The latter was alongside Royal Oak at the time of the attack, and was instrumental in rescuing most of the survivors. The author states that only two drifters were operational at the time, so your grandfathers' would have been the other one.
So, no 'Fountain' but there was a 'Shower'!
My source for much of the above is 'Nightmare at Scapa Flow' by HJ Weaver. An excellent read if you want to get into the fine detail of what actually happened that night. The author's list of ships at Scapa that night is based on the Naval Pink lists, and ship logs.
Kind regards