A pinhole in an Atwood water heater tank, typically made of a core of high-strength aluminum, could be a result of electrolysis. This can occur when there's a reaction between the aluminum and any dissimilar metals, such as copper in the water. Regular inspections on a yearly basis can help detect such issues early.