Company will target activity in north of Scotland amid expected jobs boom