A “derelict” splash park could be saved and brought back into use after more than five years out of action.