How to make brew installed software take effect over the manually installed one?
The easiest solution would be to simply delete the old version of the software.

If you want to keep both, you'll need to change your $PATH environment variable so that the location of the new version appears before the location of the old version. Do this by editing ~/.bash_profile.