The former New England Patriots quarterback rented the waterfront property after signing with the Tampa Bay Buccaneers earlier this year