This depends on your condition before treatment. Changes to your profile can generally be quite noticeable, and in some cases, changes when viewed from the front can also be significant.
If you do not want changes to your face, orthodontic treatment can straighten your teeth without changing your facial appearance. If you want a more noticeable change, orthodontic treatment can create a greater change.