1) In legal documents it is customary to have initial footnotes that use symbols (*, dagger) in introductory material and numbered footnotes after that. How can get get a mix of numbering styles in InDesign.
2) Is there any option to have the footnote follow the text rather than be at the bottom of the page?
You can fake footnotes with cross-references to paragraphs that capture their auto-numbers. Create autonumbered paragraph styles for the fake notes. Create cross-reference formats that capture the autonumbers. Create character formats that resemble true footnotes - superscript, for example - and use them in the cross-reference formats.
Only one numbered list is needed for the incremental fake autonumbered footnotes.
However, for each fake special character (*, †, etc.) footnote, you'll need a different paragraph style. Create the special characters in the Numbering Style > Numbering text input box. Capture the special character with cross-reference to these paragraphs.
Unlike real footnotes, the reference numbers or special characters in main text don't automatically renumber when they're moved to a different position in the order. For example, moving fake footnote 3's reference number earlier in main text to between fake note 1's reference number, and fake note 2's reference number, doesn't adjust the number, because it's capturing the autonumber of the fake footnote paragraph, which isn't moved when its reference number is moved. Similarly, moving a fake footnote paragraph to a different position in the order doesn't automatically update its reference number in main text; you'll need to highlight its cross-reference in the Cross-References area of the Hyperlinks panel, open the Edit Cross-References dialog box by double clicking the highlighted reference (or choosing Cross-Reference Options from the Hyperlinks panel's fly-out menu) and clicking OK.
Yes, it's work. The redeeming notion is that these fake notes probably won't need to be rearranged often, and any broken references will appear in the panel.
Search Google for terms like "InDesign cross-references," and "InDesign numbered lists," without quotes for details.