A Leicestershire tourist attraction needs £490,000 worth of repairs after being damaged by water leaks, a council has said.