Water gun with submersible pump