Historic pumping station opens its doors to the public