I'd hesitate to do it, bud. It IS possible to leverage your investment with borrowed fujnds, depending if you have (a) a low, fixed-interest rate home equity loan (which is becoming harder to find), (b) a relatively medium-length time horizon of 5-15 years to invest (it would be a killer if the market went south for 2 or 3 years regardless of how good your advisor is, so you want time to have a chance to recover, and (c) he's damn good at investing.
Look at it this way. Let's say you DO lend him $100,000 and you borrow it at 6.5%, for example. You get an additional tax break on the home interest, which probably cuts your effective rate of borrowing to about 6% or so (depending on your tax bracket). Then, let's say, your killer advisor friend says you can make an average 10% annualized on your money in an aggressive portfolio (remember he's SAYING this...) In that best-case scenario, you are basically netting a profit (after paying the interest on the loan after taxes) of 4% or $4,000 on your $100,000 investment. THEN you'll have to pay taxes on some of the ivnestment earnings (unless he puts you in some annuity product, which I suspect he will so he can make bigger commissions from the insurance company selling it to you...) That cuts your net return even more.
Do you REALLY want that much risk for that little overall reward?