Start Terminal in AppleScript
You can force Terminal to become frontmost by adding the line:

activate application "Terminal"


into your applescript. 

if you launch Terminal with:

tell application "Terminal" to open location "ssh://user@example.com"


then Terminal won't open an extra window.