Not sure about fresh water but I know metal in a saltwater reef is really bad.
I have read stories about a dropped screw, dime or tack and people having to tear apart their tanks to find it.
I dropped a tiny screw it the back of a nanocube filter once while replacing a bulb and it was a pain to get it out.