Do yourself a big favor. Forget SCSI, add an ATA-66 board if you have a free PCI slot-they run about $100- (or use the onboard ATA your G4 should already have) buy yourself one or more fast and cheap 7200RPM large capacity ATA Hard Drives (40/60/80+gigs) and call it a night.
Modern 7200RPM ATA devices are more than adequate for video editing/capture/playback/audio work, etc. I've found that capturing full 720x480 video via Firewire to ATA drives without dropping a single frame works great. In fact, I've even captured to 5400 speed drives without a single frame drop. Also, I own a G4/400 that I use to capture and edit video with using ATA drives, so the MHZ speed of your Mac isn't an issue either.
SCSI is quite simply a waste of your money and probably overkill. Compare the capacity/price you get with SCSI hardware with the capacity/price of ATA drives (even if you buy a seperate controller it's no contest).
At anyrate, if you've been so convinced of the absolute need for SCSI devices, (nothing wrong with them, just that you don't really need it) then to answer one of your questions; no, you don't need the devices to be the same brand/model/etc. Your Mac could care less what brand of Harddrive(s) you use, and any combination of them that is Mac compatible ( which is virtually any modern name-brand drive, ATA or SCSI) will all work with each other fine.
Also if you must go with SCSI, 10,000RPM is a bit overkill. You most certainly don't need to pay more for that. Full frame digital video capture and playback doesn't begin to fully tax drives at 7200RPM.
I recommend if you go with ATA, look into IBM harddrives. A fast, quiet 40 gig IBM runs a little over $100 these days. A 60 gig can be had for as low as $140. See what any SCSI hard dive is going for in those capacity ranges.