In a home tournament, and depending on the players in your group and the number of players on any given night, you might want to consider whether increasing or decreasing the payout structure will affect the likelihood of players returning. If some players think that they will never get paid because there are two strong players and only the top two have a shot at the money, they may decide to watch reruns of GOT instead.
Some groups I play in will increase the number of payouts if there are x number of total buyins (including rebuys), while others base it on the number of bums in seats. I personally prefer the latter, but it's up to you as Tournament Director (TD) to decide.
With 6-7 players (or total buyins, depending on your decision on the above), two places paid is 33%-29% of the players getting paid, which is fine IMO. Increasing the payout to three places paid changes it to 50%-43%, which is probably a bit generous. Stronger players might be upset that they get rewarded less, but weaker players have a better shot at the money and may return more.
With a couple more players (or buyins, again depending on your decision as TD) in the mix (8-9), the numbers change to 25%-22% for two positions paid, 38%-33% for three.
Personally for a one or two table tournament I like to keep things centered around the one in three ratio (one position paid for 2-4 players, two paid for 5-7, three for 8-10, etc. You can work the amounts for each payout so that the lowest payout gets their buyin back plus a little more (based on no rebuys). For example with 2 paid in a 6 player game, and if you set the payout structure to 70-30 as suggested above, top place gets 4.2 times the buyin, while second place gets 1.8 times the buyin. With 9 players and three places paid, you could go 50-30-20 for 4.5x, 2.7x, 1.8x.
Bottom line is that you as TD get to set the structure to whatever you want, but those decisions will affect the flavor of the game, and therefore the likelihood of players wanting to return for more.
Best of luck with hosting, and I hope you and your group have a blast!