But why sink an empty barrel?
Somebody made a raft with barrels for flotation and when it rotted away a rusted-out barrel ended up on the bottom. Not Rocket science.
There are a number of ways a barrel could have floated on the lake until it finally sank when it filled up with water.