Is there really an endless water world in Super Mario Bros.?

Yes. You use the warp zone at the end of level 1-2, but instead of getting to it the normal way (jumping on top of the bricks at the top of the screen), you crouch, and hop into the pipe just before the warp zone. This video shows the proper technique:

Good luck!