Any aquarium aficionados out there?

[Conjuay]

2. as long as it's a fresh water tank, you should be fine.

The bubblers will create more water movement, which will allow more off-gasing of CO2
and add more oxygen. It helps keep the detritus moving instead of settling to the bottom, which improves filtration.
The only time I wouldn't recommend it is in tanks that have naturally sedentary fish- Bettas, for example who tend to live in quite stagnant pools. AND goldfish that have such outrageous fins they can barely keep moving.

Salt tanks- no. There is a problem called 'salt creep' that makes everything nasty.