One of the Killarney Lakes' most visited sites set to re-ope