If you dont put a water valve on it (keep the shower head above the water tank) then you could just use the valve on your scuba tank to put air into the water tank and force the water up the shower head tube (connected near the bottom of course). If the head were just near the top of the water line, then the pressure in the tank would always be limited to the backpressure of the shower head (couple psi at most). That way you dont need any pressure rating. Just shut off the scuba tank when you want the water flow to stop.
You run into trouble when you use a valve on the water side, because now you have lost all means of keeping the pressure near 0. If the scuba tank is on and the valve is closed, you better hope the tank is full of water so it doesnt explode.
I tried it the other way when I was a kid. I made a "super soaker" out of a plastic bottle with a water valve and a tire valve threaded into tapped holes in the top (yes, I'm a nerd). Even wrapped with a ton of duct tape, it couldn't take more than 20-30 psi before the screw-on top would blow off.
I later made a top-off for my salt water fish tanks when I was single and out on business trips alot (1 gallon of evaporation per day). I used 5 gallon salt bucket with two holes in the snap-on lid. I put a tube in each hole (tight fit), one to the bottom and one just barely in there. A float switch in the fish tank from Granger turned on a small air pump (the kind that blows bubbles in fish tanks). The air pushed the water up the tube from the bottom of the bucket and into the tank. The air pump would stop at about 3 feet of head so no part of this rig ever saw more than 1-2 psi. I didn't even have to do anything to hold the lid on. The snap fit was enough.
Sorry for the rambling post...
Bryan.