Should water heaters be turned off (for safety) when not in use?
No: water heaters are designed to be left on 24/7/365. You might turn one off if you're leaving for a vacation to save energy, but safety isn't part of the decision.