CCK field type 'View Reference' which allows users to link to, or include views into nodes.
Very well maintained, hugely informative project page.