any SS should be OK in freshwater. If you have some salt in the water, you will want to get 300 series (e.g. 316) stainless. it has a higher nickel content, and is more resistant to corrosion. The most rapid form of corrosion (galvanic) only occurs when you have two different metals in contact (e.g. aluminum screws in an iron sheet).
SS is also more likely to corrode under anaerobic conditions. If the screws are deep down in the substrate, they are more likely to break down. As long as you check the screws visually every month or so, you should be able to tell if there are any problems.