I really like Ultimate sport are you familiar with it?
Yes - it's also known as ultimate frisbee, a non-contact team sport played with a flying disc.  
I need to get one of the goals to put behind my house.
Then your backyard can be a playing field.  Ultimate sport was also developed in 1968 by a group of high school students in New Jersey.
That was not that long ago, I wonder how many people play now a days?
A lot of people play as it's part of a school physical education class.  The focus on the sport is a bit different than other sports - it focuses on self-officiating even at the highest level of competition.
I  think it would be interesting to see high level players play
It would - I'm sure high level players will be better at all aspects of the game.  They will likely be better at interceptions and have a very low incomplete pass rate.
Do the hold any tournaments for it>?
They don't hold any official tournaments such as the Olympics or anything like that.   I think it may be due to the fact that players ply regardless of whether conditions, so even if it rains, they play on.  That might be a hard sport to watch.