I have a 6" airstone in the back of the tank and it really just makes the tank seem so much more real and better to enjoy. It helps create water movement and my fish such as my corys love to swim through it. The only problem I could really see is the tubing which may look a little weird inside an aquarium but hopefully you have some plants or rocks to cover that up. If noise is a problem there are plenty of air pumps that are silent and unnoticable, just make sure the pump isn't leaning against the wall or anything else cuz thats when it creates noise.
Overall air stones are cheap, reliable, look great and every aquarist should have some =) good luck