I have a similar setup - 5 iPhones, a couple of computers, iPad, etc.
I have the masters on my Pro - it's always on and powerful enough to keep iTunes and iPhoto running in the background.
Each user has their own iCloud account for email, calendars, etc.
We share a single family AppleID for purchases - this is setup on each device for Music, Videos, and AppStore.
Given that all music, videos etc are bought using the same ID, when they're bought on a device they sync into iTunes on the central library Mac automatically. Each device can optionally turn on downloads of purchased items from other devices. That's a per device setting.
Each user controls their own iPhotos - this isn't a problem for the kids. Between my wife and I, put our own photos into our own iPhoto libraries. Both are shared, and we can drag and drop between them as needed within iPhoto. This doesn't sync automatically, but it's easy to tell on the event level what needs updating.
Home Sharing allows all devices to play whatever music and videos within the houses' wifi network, including on the AppleTVs. HomeSharing also (at least used to) allow for automatic syncing between devices to keep everything on one account, if added outside of the store. With laptops for the kids, they can keep their own smaller libraries and stream via HomeSharing in the house, and copy to their own accounts to store stuff for outside the house.
Outside the house because we're using the single account, everyone can play any music via iTunes Match. With the latest Apple update, this now includes movies and TV shows bought through iTMS.
Yes, you can configure Mac OS X 10.7, aka Lion, to serve multiple web sites using URLs like http://[my-local-ip-address]/~mytestsite.
The format of URL you suggest can be achieved by creating a new user for each site, and storing the web pages in that user's Sites folder.
Alternatively, you could create subfolders within your site's folder:
http://[my-local-ip-address]/~[myusername]/site1http://[my-local-ip-address]/~[myusername]/site2http://[my-local-ip-address]/~[myusername]/site3
Going another step further, you can customise the Apache httpd 2 configuration files at /etc/apache2/users/[myusername] to tweak the set up to your exact needs.
Best Answer
This may be considered a duplicate question as I arrived at the solution from this answer.. I didn't give up searching, sorry about that.
To help others I'll mention what I got wrong.
I didn't have to change any firewall or sharing settings - it was to do with where the application was being hosted. I assumed that when I viewed 192.168.0.164 from the other Mac, it'd magically map to the host's 127.0.0.1... that is not the case!
So instead I explicitly hosted the application on 192.168.0.164 instead of 127.0.0.1 and it worked fine!