There is no water park currently operating in Red Bay, Alabama. Red Bay is a small city in Franklin County in the northwestern part of the state. The closest water park to Red Bay is or McFarland Park Beach & Aquatics Center in Florence, AL, but neither is a large-scale water park.