Can one of a Fund's limited partners also become a venture partner or other type of advisor or consultant to the Fund (via the General Partner entity)?

Yes - however in doing so, the limited partner will generally lose their "limited" status with respect to liability, because they may wield influence over the Fund's decision-making processes. They may become liable for any actions taken by the General Partner of the fund that have potentially adverse implications for the Fund's limited partners.